2024-07-22 10:40:39,488 [ 541113 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2024-07-22 10:40:39,488 [ 541113 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2024-07-22 10:40:39,488 [ 541113 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2024-07-22 10:40:39,488 [ 541113 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_0zvd8x --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_s3_queue/test.py::test_max_set_age test_storage_s3_queue/test.py::test_max_set_size test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered]' 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered]' 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered]' 'test_storage_s3_queue/test.py::test_processed_file_setting[1]' 'test_storage_s3_queue/test.py::test_processed_file_setting[5]' 'test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1]' 'test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5]' 'test_storage_s3_queue/test.py::test_processing_threads[ordered]' 'test_storage_s3_queue/test.py::test_processing_threads[unordered]' test_storage_s3_queue/test.py::test_s3_client_reused test_storage_s3_queue/test.py::test_settings_check 'test_storage_s3_queue/test.py::test_shards[ordered-1]' 'test_storage_s3_queue/test.py::test_shards[ordered-8]' 'test_storage_s3_queue/test.py::test_shards[unordered-1]' 'test_storage_s3_queue/test.py::test_shards[unordered-8]' 'test_storage_s3_queue/test.py::test_shards_distributed[ordered-1]' 'test_storage_s3_queue/test.py::test_shards_distributed[ordered-8]' 'test_storage_s3_queue/test.py::test_shards_distributed[unordered-1]' 'test_storage_s3_queue/test.py::test_shards_distributed[unordered-8]' 'test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered]' 'test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered]' 'test_storage_s3_queue/test.py::test_streaming_to_view_[ordered]' 'test_storage_s3_queue/test.py::test_streaming_to_view_[unordered]' test_storage_s3_queue/test.py::test_upgrade test_storage_url_with_proxy/test.py::test_s3_with_proxy_list test_store_cleanup/test.py::test_store_cleanup test_system_clusters_actual_information/test.py::test test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 'test_system_flush_logs/test.py::test_system_logs[system.metric_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.part_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.query_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.text_log-0]' 'test_system_flush_logs/test.py::test_system_logs[system.trace_log-1]' test_system_flush_logs/test.py::test_system_logs_non_empty_queue test_system_flush_logs/test.py::test_system_suspend 'test_table_function_mongodb/test.py::test_auth_source[False]' 'test_table_function_mongodb/test.py::test_complex_data_type[False]' 'test_table_function_mongodb/test.py::test_incorrect_data_type[False]' 'test_table_function_mongodb/test.py::test_missing_columns[False]' 'test_table_function_mongodb/test.py::test_no_credentials[False]' 'test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]' 'test_table_function_mongodb/test.py::test_secure_connection[True]' 'test_table_function_mongodb/test.py::test_simple_select[False]' test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select test_text_log_level/test.py::test_basic 'test_throttling/test.py::test_backup_throttling[no_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling]' test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server 'test_throttling/test.py::test_read_throttling[no_local_throttling]' 'test_throttling/test.py::test_read_throttling[no_remote_throttling]' 'test_throttling/test.py::test_read_throttling[server_local_throttling]' 'test_throttling/test.py::test_read_throttling[server_remote_throttling]' 'test_throttling/test.py::test_read_throttling[user_local_throttling]' 'test_throttling/test.py::test_read_throttling[user_remote_throttling]' 'test_throttling/test.py::test_write_throttling[local_server_throttling]' 'test_throttling/test.py::test_write_throttling[local_user_throttling]' 'test_throttling/test.py::test_write_throttling[no_local_throttling]' 'test_throttling/test.py::test_write_throttling[no_remote_throttling]' 'test_throttling/test.py::test_write_throttling[server_remote_throttling]' 'test_throttling/test.py::test_write_throttling[user_remote_throttling]' test_transactions/test.py::test_rollback_unfinished_on_restart1 test_transactions/test.py::test_rollback_unfinished_on_restart2 test_truncate_database/test_distributed.py::test_truncate_database_distributed test_user_directories/test.py::test_duplicates test_user_directories/test.py::test_local_directories test_user_directories/test.py::test_memory test_user_directories/test.py::test_mixed_style test_user_directories/test.py::test_old_style test_user_directories/test.py::test_relative_path test_user_valid_until/test.py::test_basic test_user_valid_until/test.py::test_details test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_version_update_after_mutation/test.py::test_upgrade_while_mutation test_zookeeper_config/test_secure.py::test_secure_connection -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: reportlog-0.4.0, random-0.2, repeat-0.9.3, xdist-3.5.0, order-1.0.1, timeout-2.2.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [92 items] scheduling tests via LoadFileScheduling test_storage_s3_queue/test.py::test_max_set_age test_throttling/test.py::test_backup_throttling[no_local_throttling] test_table_function_redis/test.py::test_create_table test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] test_user_valid_until/test.py::test_basic test_storage_url_with_proxy/test.py::test_s3_with_proxy_list test_table_function_mongodb/test.py::test_auth_source[False] test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_transactions/test.py::test_rollback_unfinished_on_restart1 test_user_directories/test.py::test_duplicates [gw2] [ 1%] PASSED test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] test_system_flush_logs/test.py::test_system_logs[system.part_log-1] [gw2] [ 2%] PASSED test_system_flush_logs/test.py::test_system_logs[system.part_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_log-1] [gw2] [ 3%] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_log-1] test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] [gw2] [ 4%] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] test_system_flush_logs/test.py::test_system_logs[system.text_log-0] [gw2] [ 5%] PASSED test_system_flush_logs/test.py::test_system_logs[system.text_log-0] test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] [gw2] [ 6%] PASSED test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] test_system_flush_logs/test.py::test_system_logs_non_empty_queue [gw2] [ 7%] PASSED test_system_flush_logs/test.py::test_system_logs_non_empty_queue test_system_flush_logs/test.py::test_system_suspend [gw2] [ 8%] PASSED test_system_flush_logs/test.py::test_system_suspend [gw1] [ 9%] PASSED test_throttling/test.py::test_backup_throttling[no_local_throttling] [gw9] [ 10%] PASSED test_storage_url_with_proxy/test.py::test_s3_with_proxy_list [gw4] [ 11%] PASSED test_user_directories/test.py::test_duplicates test_user_directories/test.py::test_local_directories test_truncate_database/test_distributed.py::test_truncate_database_distributed [gw3] [ 13%] PASSED test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_complex_data_type[False] [gw3] [ 14%] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_incorrect_data_type[False] [gw3] [ 15%] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] test_table_function_mongodb/test.py::test_missing_columns[False] [gw3] [ 16%] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] test_table_function_mongodb/test.py::test_no_credentials[False] [gw3] [ 17%] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] [gw3] [ 18%] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] [gw1] [ 19%] PASSED test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] [gw6] [ 20%] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart1 test_transactions/test.py::test_rollback_unfinished_on_restart2 [gw4] [ 21%] PASSED test_user_directories/test.py::test_local_directories test_user_directories/test.py::test_memory test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] [gw1] [ 22%] PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] [gw6] [ 23%] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart2 [gw5] [ 25%] PASSED test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type [gw5] [ 26%] PASSED test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select [gw4] [ 27%] PASSED test_user_directories/test.py::test_memory test_user_directories/test.py::test_mixed_style [gw5] [ 28%] PASSED test_table_function_redis/test.py::test_simple_select test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] [gw1] [ 29%] PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] [gw7] [ 30%] PASSED test_user_valid_until/test.py::test_basic test_user_valid_until/test.py::test_details [gw7] [ 31%] PASSED test_user_valid_until/test.py::test_details test_store_cleanup/test.py::test_store_cleanup [gw4] [ 32%] PASSED test_user_directories/test.py::test_mixed_style test_user_directories/test.py::test_old_style test_throttling/test.py::test_backup_throttling[server_local_throttling] [gw2] [ 33%] PASSED test_truncate_database/test_distributed.py::test_truncate_database_distributed test_system_clusters_actual_information/test.py::test [gw4] [ 34%] PASSED test_user_directories/test.py::test_old_style test_user_directories/test.py::test_relative_path [gw1] [ 35%] PASSED test_throttling/test.py::test_backup_throttling[server_local_throttling] [gw4] [ 36%] PASSED test_user_directories/test.py::test_relative_path [gw8] [ 38%] PASSED test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_version_update_after_mutation/test.py::test_upgrade_while_mutation test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] test_zookeeper_config/test_secure.py::test_secure_connection test_text_log_level/test.py::test_basic [gw3] [ 39%] PASSED test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] [gw8] [ 40%] PASSED test_version_update_after_mutation/test.py::test_upgrade_while_mutation test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue [gw0] [ 41%] PASSED test_storage_s3_queue/test.py::test_max_set_age test_storage_s3_queue/test.py::test_max_set_size [gw1] [ 42%] PASSED test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] [gw9] [ 43%] PASSED test_text_log_level/test.py::test_basic [gw1] [ 44%] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] [gw1] [ 45%] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] [gw0] [ 46%] PASSED test_storage_s3_queue/test.py::test_max_set_size test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch [gw3] [ 47%] PASSED test_table_function_mongodb/test.py::test_simple_select[False] [gw0] [ 48%] PASSED test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] [gw2] [ 50%] PASSED test_zookeeper_config/test_secure.py::test_secure_connection test_throttling/test.py::test_backup_throttling[user_local_throttling] [gw8] [ 51%] PASSED test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue [gw1] [ 52%] PASSED test_throttling/test.py::test_backup_throttling[user_local_throttling] [gw0] [ 53%] PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] [gw0] [ 54%] PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] [gw1] [ 55%] PASSED test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] [gw6] [ 56%] PASSED test_store_cleanup/test.py::test_store_cleanup [gw0] [ 57%] PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] test_storage_s3_queue/test.py::test_processed_file_setting[1] [gw1] [ 58%] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] [gw1] [ 59%] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] test_throttling/test.py::test_backup_throttling_override [gw0] [ 60%] PASSED test_storage_s3_queue/test.py::test_processed_file_setting[1] test_storage_s3_queue/test.py::test_processed_file_setting[5] [gw0] [ 61%] PASSED test_storage_s3_queue/test.py::test_processed_file_setting[5] test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] [gw1] [ 63%] PASSED test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server [gw1] [ 64%] PASSED test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server [gw0] [ 65%] PASSED test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] [gw1] [ 66%] PASSED test_throttling/test.py::test_max_mutations_bandwidth_for_server [gw7] [ 67%] PASSED test_system_clusters_actual_information/test.py::test test_throttling/test.py::test_read_throttling[no_local_throttling] [gw1] [ 68%] PASSED test_throttling/test.py::test_read_throttling[no_local_throttling] test_throttling/test.py::test_read_throttling[no_remote_throttling] [gw1] [ 69%] PASSED test_throttling/test.py::test_read_throttling[no_remote_throttling] test_throttling/test.py::test_read_throttling[server_local_throttling] [gw0] [ 70%] PASSED test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] test_storage_s3_queue/test.py::test_processing_threads[ordered] [gw1] [ 71%] PASSED test_throttling/test.py::test_read_throttling[server_local_throttling] [gw0] [ 72%] PASSED test_storage_s3_queue/test.py::test_processing_threads[ordered] test_storage_s3_queue/test.py::test_processing_threads[unordered] test_throttling/test.py::test_read_throttling[server_remote_throttling] [gw0] [ 73%] PASSED test_storage_s3_queue/test.py::test_processing_threads[unordered] test_storage_s3_queue/test.py::test_s3_client_reused [gw1] [ 75%] PASSED test_throttling/test.py::test_read_throttling[server_remote_throttling] test_throttling/test.py::test_read_throttling[user_local_throttling] [gw0] [ 76%] PASSED test_storage_s3_queue/test.py::test_s3_client_reused test_storage_s3_queue/test.py::test_settings_check [gw1] [ 77%] PASSED test_throttling/test.py::test_read_throttling[user_local_throttling] [gw0] [ 78%] PASSED test_storage_s3_queue/test.py::test_settings_check test_storage_s3_queue/test.py::test_shards[ordered-1] test_throttling/test.py::test_read_throttling[user_remote_throttling] [gw1] [ 79%] PASSED test_throttling/test.py::test_read_throttling[user_remote_throttling] [gw0] [ 80%] PASSED test_storage_s3_queue/test.py::test_shards[ordered-1] test_storage_s3_queue/test.py::test_shards[ordered-8] test_throttling/test.py::test_write_throttling[local_server_throttling] [gw1] [ 81%] PASSED test_throttling/test.py::test_write_throttling[local_server_throttling] test_throttling/test.py::test_write_throttling[local_user_throttling] [gw0] [ 82%] PASSED test_storage_s3_queue/test.py::test_shards[ordered-8] test_storage_s3_queue/test.py::test_shards[unordered-1] [gw1] [ 83%] PASSED test_throttling/test.py::test_write_throttling[local_user_throttling] test_throttling/test.py::test_write_throttling[no_local_throttling] [gw1] [ 84%] PASSED test_throttling/test.py::test_write_throttling[no_local_throttling] [gw0] [ 85%] PASSED test_storage_s3_queue/test.py::test_shards[unordered-1] test_storage_s3_queue/test.py::test_shards[unordered-8] test_throttling/test.py::test_write_throttling[no_remote_throttling] [gw1] [ 86%] PASSED test_throttling/test.py::test_write_throttling[no_remote_throttling] test_throttling/test.py::test_write_throttling[server_remote_throttling] [gw1] [ 88%] PASSED test_throttling/test.py::test_write_throttling[server_remote_throttling] [gw0] [ 89%] PASSED test_storage_s3_queue/test.py::test_shards[unordered-8] test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] test_throttling/test.py::test_write_throttling[user_remote_throttling] [gw1] [ 90%] PASSED test_throttling/test.py::test_write_throttling[user_remote_throttling] [gw0] [ 91%] PASSED test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] [gw0] [ 92%] PASSED test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] [gw0] [ 93%] PASSED test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] [gw0] [ 94%] PASSED test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] [gw0] [ 95%] PASSED test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] [gw0] [ 96%] PASSED test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] [gw0] [ 97%] PASSED test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] [gw0] [ 98%] PASSED test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] test_storage_s3_queue/test.py::test_upgrade [gw0] [100%] FAILED test_storage_s3_queue/test.py::test_upgrade =================================== FAILURES =================================== _________________________________ test_upgrade _________________________________ [gw0] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_upgrade(started_cluster): node = started_cluster.instances["old_instance"] table_name = f"test_upgrade" dst_table_name = f"{table_name}_dst" keeper_path = f"/clickhouse/test_{table_name}" files_path = f"{table_name}_data" files_to_generate = 10 > create_table( started_cluster, node, table_name, "ordered", files_path, additional_settings={ "keeper_path": keeper_path, }, ) test_storage_s3_queue/test.py:1409: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ test_storage_s3_queue/test.py:203: in create_table node.query(create_query) helpers/cluster.py:3450: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 36, stderr: Received exception from server (version 23.8.11): E Code: 36. DB::Exception: Received from 172.16.9.11:9000. DB::Exception: S3Queue is experimental. You can enable it with the `allow_experimental_s3queue` setting.. Stack trace: E E 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c61ff37 in /usr/bin/clickhouse E 1. DB::Exception::Exception(int, char const (&) [90]) @ 0x000000000850f1a0 in /usr/bin/clickhouse E 2. std::shared_ptr std::__function::__policy_invoker (DB::StorageFactory::Arguments const&)>::__call_impl (DB::StorageFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::StorageFactory::Arguments const&) (.llvm.17210382074278142492) @ 0x0000000012fc4b7a in /usr/bin/clickhouse E 3. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, bool) const @ 0x0000000012663e1b in /usr/bin/clickhouse E 4. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&) @ 0x0000000011cf707e in /usr/bin/clickhouse E 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x0000000011cf04bd in /usr/bin/clickhouse E 6. DB::InterpreterCreateQuery::execute() @ 0x0000000011cfd920 in /usr/bin/clickhouse E 7. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122bfe15 in /usr/bin/clickhouse E 8. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122bb5b5 in /usr/bin/clickhouse E 9. DB::TCPHandler::runImpl() @ 0x0000000013137519 in /usr/bin/clickhouse E 10. DB::TCPHandler::run() @ 0x00000000131498f9 in /usr/bin/clickhouse E 11. Poco::Net::TCPServerConnection::start() @ 0x0000000015b42834 in /usr/bin/clickhouse E 12. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b43a31 in /usr/bin/clickhouse E 13. Poco::PooledThread::run() @ 0x0000000015c7a667 in /usr/bin/clickhouse E 14. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c7893c in /usr/bin/clickhouse E 15. ? @ 0x00007f42e04fd609 in ? E 16. ? @ 0x00007f42e0422353 in ? E . (BAD_ARGUMENTS) E (query: CREATE TABLE test_upgrade (column1 UInt32, column2 UInt32, column3 UInt32) E ENGINE = S3Queue('http://minio1:9001/root/test_upgrade_data/', 'minio','minio123', CSV) E SETTINGS s3queue_loading_retries=0,after_processing='keep',keeper_path='/clickhouse/test_test_upgrade',mode='ordered' E ) helpers/client.py:239: QueryRuntimeException ------------------------------ Captured log setup ------------------------------ 2024-07-22 10:46:51 [ 546 ] DEBUG : Executing query DROP DATABASE IF EXISTS test; CREATE DATABASE test; on instance (cluster.py:3449, query) 2024-07-22 10:46:51 [ 546 ] DEBUG : Executing query DROP DATABASE IF EXISTS test; CREATE DATABASE test; on instance2 (cluster.py:3449, query) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "GET /root?delimiter=&encoding-type=url&list-type=2&max-keys=1000&prefix= HTTP/1.1" 200 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_0.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_1.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_2.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_3.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_4.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_5.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_6.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_7.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_8.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) 2024-07-22 10:46:51 [ 546 ] DEBUG : http://172.16.9.7:9001 "DELETE /root/streaming_to_view_unordered_data/test_9.csv HTTP/1.1" 204 0 (connectionpool.py:546, _make_request) ------------------------------ Captured log call ------------------------------- 2024-07-22 10:46:51 [ 546 ] DEBUG : Executing query DROP TABLE IF EXISTS test_upgrade on old_instance (cluster.py:3449, query) 2024-07-22 10:46:51 [ 546 ] DEBUG : Executing query CREATE TABLE test_upgrade (column1 UInt32, column2 UInt32, column3 UInt32) ENGINE = S3Queue('http://minio1:9001/root/test_upgrade_data/', 'minio','minio123', CSV) SETTINGS s3queue_loading_retries=0,after_processing='keep',keeper_path='/clickhouse/test_test_upgrade',mode='ordered' on old_instance (cluster.py:3449, query) ---------------------------- Captured log teardown ----------------------------- 2024-07-22 10:46:52 [ 546 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/.env', '--project-name', 'rootteststorages3queue', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_minio.yml', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance2/docker-compose.yml', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/old_instance/docker-compose.yml', 'stop', '--timeout', '20'] (cluster.py:108, run_and_check) 2024-07-22 10:46:57 [ 546 ] WARNING : Connection dropped: outstanding heartbeat ping not received (connection.py:622, _connect_attempt) 2024-07-22 10:46:57 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:46:57 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:46:57 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:57 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:46:58 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:58 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:58 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: outstanding heartbeat ping not received (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: outstanding heartbeat ping not received (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:46:59 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:46:59 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] WARNING : Connection dropped: outstanding heartbeat ping not received (connection.py:622, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:47:00 [ 546 ] WARNING : Connection dropped: outstanding heartbeat ping not received (connection.py:622, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2024-07-22 10:47:00 [ 546 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:00 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:01 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:10 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:10 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:10 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:10 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:10 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:10 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:10 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:11 [ 546 ] WARNING : Connection dropped: socket connection error: None (connection.py:622, _connect_attempt) 2024-07-22 10:47:12 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:12 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:12 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_instance2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_instance_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_old_instance_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_resolver_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_minio1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_proxy1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_proxy2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo3_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_old_instance_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_instance_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_instance2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_minio1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo3_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_zoo1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_resolver_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_proxy1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Stopping rootteststorages3queue_proxy2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance/logs/stderr.log* || true'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance2/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance2/logs/stderr.log* || true'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/old_instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/old_instance/logs/stderr.log* || true'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/.env', '--project-name', 'rootteststorages3queue', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_minio.yml', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/instance2/docker-compose.yml', '--file', '/ClickHouse/tests/integration/test_storage_s3_queue/_instances_0/old_instance/docker-compose.yml', 'down', '--volumes'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] INFO : Connecting to 172.16.9.4(172.16.9.4):2181, use_ssl: False (connection.py:650, _connect) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_instance2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_instance_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_old_instance_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_resolver_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_minio1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_proxy1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_proxy2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo1_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo3_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo2_1 ... (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_resolver_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_proxy1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_proxy2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_old_instance_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_instance_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_instance2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo2_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_zoo3_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing rootteststorages3queue_minio1_1 ... done (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing network rootteststorages3queue_default (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stderr:Removing volume rootteststorages3queue_data1-1 (cluster.py:118, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Cleanup called (cluster.py:796, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Docker networks for project rootteststorages3queue are NETWORK ID NAME DRIVER SCOPE (cluster.py:775, print_all_docker_pieces) 2024-07-22 10:47:13 [ 546 ] DEBUG : Docker containers for project rootteststorages3queue are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:783, print_all_docker_pieces) 2024-07-22 10:47:13 [ 546 ] DEBUG : Docker volumes for project rootteststorages3queue are DRIVER VOLUME NAME (cluster.py:791, print_all_docker_pieces) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:docker container list --all --filter name='^/rootteststorages3queue_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Unstopped containers: {} (cluster.py:810, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : No running containers for project: rootteststorages3queue (cluster.py:824, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Trying to prune unused networks... (cluster.py:830, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Trying to prune unused images... (cluster.py:846, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:116, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Images pruned (cluster.py:849, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Trying to prune unused volumes... (cluster.py:855, cleanup) 2024-07-22 10:47:13 [ 546 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:108, run_and_check) 2024-07-22 10:47:13 [ 546 ] DEBUG : Stdout:1 (cluster.py:116, run_and_check) =============================== warnings summary =============================== test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/helpers/cluster.py:2495: DeprecationWarning: database_names is deprecated. Use list_database_names instead. logging.debug(f"Connected to Mongo dbs: {connection.database_names()}") test_table_function_mongodb/test.py::test_auth_source[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:227: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead admin_db.add_user( test_table_function_mongodb/test.py::test_complex_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:89: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /usr/local/lib/python3.10/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6 warnings.warn("Creating a user with the read_only option " test_table_function_mongodb/test.py::test_incorrect_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:124: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_missing_columns[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:263: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:186: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_throttling/test.py::test_backup_throttling[no_local_throttling] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1099: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.6.5'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( test_table_function_mongodb/test.py::test_secure_connection[True] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:145: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:47: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection test_zookeeper_config/test_secure.py::test_secure_connection /usr/local/lib/python3.10/dist-packages/kazoo/handlers/utils.py:225: DeprecationWarning: ssl.PROTOCOL_TLS is deprecated context = ssl.SSLContext(ssl.PROTOCOL_SSLv23) -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 119.89s call test_system_clusters_actual_information/test.py::test 65.91s call test_store_cleanup/test.py::test_store_cleanup 32.60s setup test_storage_s3_queue/test.py::test_max_set_age 32.04s setup test_version_update_after_mutation/test.py::test_mutate_and_upgrade 26.59s call test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] 26.41s call test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] 26.40s call test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] 25.99s teardown test_throttling/test.py::test_write_throttling[user_remote_throttling] 25.73s setup test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 25.50s call test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] 24.11s setup test_table_function_redis/test.py::test_create_table 23.19s teardown test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 22.33s teardown test_storage_s3_queue/test.py::test_upgrade 21.37s setup test_table_function_mongodb/test.py::test_secure_connection[True] 20.41s call test_storage_s3_queue/test.py::test_max_set_size 19.67s setup test_zookeeper_config/test_secure.py::test_secure_connection 19.10s call test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] 19.09s call test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] 18.78s call test_throttling/test.py::test_backup_throttling_override 18.52s setup test_table_function_mongodb/test.py::test_auth_source[False] 16.87s setup test_transactions/test.py::test_rollback_unfinished_on_restart1 16.84s setup test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 16.72s setup test_table_function_mongodb/test.py::test_simple_select[False] 16.63s call test_storage_s3_queue/test.py::test_s3_client_reused 16.30s setup test_throttling/test.py::test_backup_throttling[no_local_throttling] 15.04s call test_storage_s3_queue/test.py::test_processed_file_setting[1] 14.01s call test_storage_s3_queue/test.py::test_processed_file_setting[5] 13.73s setup test_user_directories/test.py::test_duplicates 13.68s call test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] 13.57s call test_user_valid_until/test.py::test_basic 13.41s setup test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 13.22s call test_storage_s3_queue/test.py::test_shards[ordered-8] 13.19s call test_storage_s3_queue/test.py::test_shards[ordered-1] 13.16s call test_storage_s3_queue/test.py::test_shards[unordered-1] 13.10s setup test_text_log_level/test.py::test_basic 13.06s call test_storage_s3_queue/test.py::test_shards[unordered-8] 12.95s setup test_user_valid_until/test.py::test_basic 12.83s call test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] 12.74s call test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] 12.68s call test_storage_s3_queue/test.py::test_max_set_age 11.40s call test_throttling/test.py::test_read_throttling[user_local_throttling] 11.33s setup test_truncate_database/test_distributed.py::test_truncate_database_distributed 10.92s setup test_system_clusters_actual_information/test.py::test 10.81s call test_throttling/test.py::test_read_throttling[user_remote_throttling] 10.80s call test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 10.77s call test_throttling/test.py::test_backup_throttling[user_local_throttling] 10.77s call test_throttling/test.py::test_write_throttling[user_remote_throttling] 10.76s call test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 10.71s call test_throttling/test.py::test_write_throttling[local_user_throttling] 9.48s teardown test_truncate_database/test_distributed.py::test_truncate_database_distributed 9.03s setup test_store_cleanup/test.py::test_store_cleanup 8.64s call test_table_function_mongodb/test.py::test_simple_select[False] 7.91s call test_zookeeper_config/test_secure.py::test_secure_connection 7.23s call test_throttling/test.py::test_max_mutations_bandwidth_for_server 7.20s call test_throttling/test.py::test_max_merges_bandwidth_for_server 7.02s call test_throttling/test.py::test_read_throttling[server_local_throttling] 6.90s call test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 6.90s call test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 6.84s call test_throttling/test.py::test_read_throttling[server_remote_throttling] 6.78s call test_throttling/test.py::test_backup_throttling[server_local_throttling] 6.72s call test_throttling/test.py::test_write_throttling[server_remote_throttling] 6.63s call test_throttling/test.py::test_write_throttling[local_server_throttling] 6.35s call test_version_update_after_mutation/test.py::test_mutate_and_upgrade 4.94s teardown test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 4.31s teardown test_system_clusters_actual_information/test.py::test 4.06s call test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 3.99s teardown test_table_function_mongodb/test.py::test_simple_select[False] 3.96s call test_transactions/test.py::test_rollback_unfinished_on_restart1 3.94s teardown test_zookeeper_config/test_secure.py::test_secure_connection 3.93s call test_storage_s3_queue/test.py::test_settings_check 3.89s teardown test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 3.88s teardown test_text_log_level/test.py::test_basic 3.87s call test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 3.78s call test_user_directories/test.py::test_relative_path 3.77s call test_user_directories/test.py::test_mixed_style 3.76s teardown test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 3.74s call test_user_directories/test.py::test_old_style 3.71s call test_user_directories/test.py::test_duplicates 3.70s call test_user_directories/test.py::test_memory 3.70s teardown test_throttling/test.py::test_backup_throttling_override 3.70s teardown test_throttling/test.py::test_backup_throttling[server_local_throttling] 3.69s teardown test_throttling/test.py::test_backup_throttling[no_local_throttling] 3.69s teardown test_version_update_after_mutation/test.py::test_upgrade_while_mutation 3.69s call test_user_directories/test.py::test_local_directories 3.68s teardown test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 3.67s teardown test_throttling/test.py::test_backup_throttling[user_local_throttling] 3.67s teardown test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 3.67s teardown test_throttling/test.py::test_write_throttling[local_server_throttling] 3.66s teardown test_throttling/test.py::test_write_throttling[no_local_throttling] 3.66s teardown test_throttling/test.py::test_read_throttling[user_local_throttling] 3.66s teardown test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 3.65s teardown test_user_valid_until/test.py::test_details 3.65s teardown test_throttling/test.py::test_max_mutations_bandwidth_for_server 3.64s teardown test_throttling/test.py::test_write_throttling[no_remote_throttling] 3.64s teardown test_throttling/test.py::test_read_throttling[no_remote_throttling] 3.64s teardown test_throttling/test.py::test_write_throttling[local_user_throttling] 3.64s teardown test_throttling/test.py::test_write_throttling[server_remote_throttling] 3.41s teardown test_table_function_redis/test.py::test_simple_select 3.36s call test_transactions/test.py::test_rollback_unfinished_on_restart2 2.95s teardown test_transactions/test.py::test_rollback_unfinished_on_restart2 2.77s call test_version_update_after_mutation/test.py::test_upgrade_while_mutation 2.70s teardown test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 2.66s teardown test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 2.62s teardown test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 2.62s teardown test_throttling/test.py::test_read_throttling[user_remote_throttling] 2.61s teardown test_throttling/test.py::test_read_throttling[server_local_throttling] 2.59s teardown test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 2.59s teardown test_throttling/test.py::test_max_merges_bandwidth_for_server 2.59s teardown test_throttling/test.py::test_read_throttling[no_local_throttling] 2.57s teardown test_throttling/test.py::test_read_throttling[server_remote_throttling] 2.14s teardown test_user_directories/test.py::test_relative_path 2.12s call test_storage_s3_queue/test.py::test_processing_threads[ordered] 2.08s teardown test_system_flush_logs/test.py::test_system_suspend 2.07s call test_storage_s3_queue/test.py::test_processing_threads[unordered] 1.94s teardown test_store_cleanup/test.py::test_store_cleanup 1.57s call test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] 1.57s call test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] 1.26s call test_system_flush_logs/test.py::test_system_suspend 1.25s call test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] 1.25s call test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] 1.19s call test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 0.90s call test_truncate_database/test_distributed.py::test_truncate_database_distributed 0.65s call test_text_log_level/test.py::test_basic 0.57s call test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch 0.53s call test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 0.52s call test_table_function_redis/test.py::test_create_table 0.52s setup test_storage_s3_queue/test.py::test_processed_file_setting[1] 0.51s setup test_storage_s3_queue/test.py::test_s3_client_reused 0.50s setup test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] 0.49s setup test_storage_s3_queue/test.py::test_shards[ordered-8] 0.48s setup test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] 0.47s setup test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] 0.47s setup test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] 0.47s setup test_storage_s3_queue/test.py::test_processing_threads[unordered] 0.47s setup test_storage_s3_queue/test.py::test_shards[unordered-8] 0.46s setup test_storage_s3_queue/test.py::test_shards[unordered-1] 0.46s setup test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] 0.46s setup test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] 0.45s setup test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] 0.38s call test_table_function_mongodb/test.py::test_secure_connection[True] 0.37s setup test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.34s call test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 0.28s call test_user_valid_until/test.py::test_details 0.25s call test_table_function_mongodb/test.py::test_complex_data_type[False] 0.24s call test_throttling/test.py::test_read_throttling[no_remote_throttling] 0.23s call test_throttling/test.py::test_backup_throttling[no_local_throttling] 0.23s call test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 0.22s call test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.21s call test_table_function_mongodb/test.py::test_auth_source[False] 0.21s call test_table_function_redis/test.py::test_data_type 0.19s call test_throttling/test.py::test_read_throttling[no_local_throttling] 0.18s call test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 0.17s setup test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch 0.17s setup test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.17s call test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 0.15s call test_throttling/test.py::test_write_throttling[no_remote_throttling] 0.13s call test_table_function_redis/test.py::test_simple_select 0.13s call test_system_flush_logs/test.py::test_system_logs_non_empty_queue 0.12s setup test_storage_s3_queue/test.py::test_max_set_size 0.12s call test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.11s setup test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] 0.11s call test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.11s call test_table_function_mongodb/test.py::test_missing_columns[False] 0.10s call test_throttling/test.py::test_write_throttling[no_local_throttling] 0.08s call test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.08s setup test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] 0.08s setup test_storage_s3_queue/test.py::test_processing_threads[ordered] 0.08s setup test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] 0.08s setup test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] 0.08s setup test_storage_s3_queue/test.py::test_processed_file_setting[5] 0.08s setup test_storage_s3_queue/test.py::test_upgrade 0.08s setup test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] 0.08s call test_table_function_mongodb/test.py::test_no_credentials[False] 0.08s setup test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] 0.07s setup test_storage_s3_queue/test.py::test_settings_check 0.07s setup test_storage_s3_queue/test.py::test_shards[ordered-1] 0.07s call test_storage_s3_queue/test.py::test_upgrade 0.07s setup test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.07s call test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.07s call test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.03s setup test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.03s setup test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.03s call test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.00s teardown test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] 0.00s setup test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] 0.00s setup test_throttling/test.py::test_backup_throttling[user_local_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards[unordered-8] 0.00s teardown test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] 0.00s teardown test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] 0.00s setup test_throttling/test.py::test_write_throttling[local_user_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] 0.00s setup test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[user_remote_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] 0.00s teardown test_storage_s3_queue/test.py::test_shards[unordered-1] 0.00s teardown test_storage_s3_queue/test.py::test_max_set_age 0.00s teardown test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] 0.00s setup test_throttling/test.py::test_write_throttling[no_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[server_local_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[no_remote_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards[ordered-1] 0.00s teardown test_storage_s3_queue/test.py::test_s3_client_reused 0.00s setup test_throttling/test.py::test_write_throttling[local_server_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[user_local_throttling] 0.00s teardown test_storage_s3_queue/test.py::test_shards[ordered-8] 0.00s setup test_user_directories/test.py::test_local_directories 0.00s setup test_throttling/test.py::test_read_throttling[no_local_throttling] 0.00s setup test_throttling/test.py::test_write_throttling[server_remote_throttling] 0.00s setup test_throttling/test.py::test_read_throttling[server_local_throttling] 0.00s setup test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] 0.00s setup test_throttling/test.py::test_max_mutations_bandwidth_for_server 0.00s setup test_throttling/test.py::test_write_throttling[no_remote_throttling] 0.00s setup test_version_update_after_mutation/test.py::test_upgrade_while_mutation 0.00s teardown test_storage_s3_queue/test.py::test_processing_threads[unordered] 0.00s setup test_throttling/test.py::test_read_throttling[server_remote_throttling] 0.00s setup test_throttling/test.py::test_max_merges_bandwidth_for_server 0.00s teardown test_user_directories/test.py::test_duplicates 0.00s setup test_throttling/test.py::test_read_throttling[user_remote_throttling] 0.00s setup test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s teardown test_transactions/test.py::test_rollback_unfinished_on_restart1 0.00s setup test_system_flush_logs/test.py::test_system_suspend 0.00s teardown test_version_update_after_mutation/test.py::test_mutate_and_upgrade 0.00s teardown test_storage_s3_queue/test.py::test_processed_file_setting[1] 0.00s setup test_user_valid_until/test.py::test_details 0.00s teardown test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.part_log-1] 0.00s teardown test_storage_s3_queue/test.py::test_processing_threads[ordered] 0.00s setup test_throttling/test.py::test_backup_throttling_override 0.00s teardown test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] 0.00s teardown test_storage_s3_queue/test.py::test_max_set_size 0.00s teardown test_user_valid_until/test.py::test_basic 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.query_log-1] 0.00s teardown test_table_function_mongodb/test.py::test_auth_source[False] 0.00s setup test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] 0.00s teardown test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] 0.00s setup test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection[True] 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] 0.00s teardown test_storage_s3_queue/test.py::test_processed_file_setting[5] 0.00s setup test_transactions/test.py::test_rollback_unfinished_on_restart2 0.00s setup test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] 0.00s teardown test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] 0.00s setup test_user_directories/test.py::test_old_style 0.00s teardown test_user_directories/test.py::test_local_directories 0.00s teardown test_table_function_redis/test.py::test_create_table 0.00s teardown test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.00s setup test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s setup test_user_directories/test.py::test_memory 0.00s setup test_table_function_redis/test.py::test_simple_select 0.00s setup test_system_flush_logs/test.py::test_system_logs_non_empty_queue 0.00s teardown test_user_directories/test.py::test_old_style 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.text_log-0] 0.00s setup test_table_function_redis/test.py::test_data_type 0.00s teardown test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] 0.00s setup test_user_directories/test.py::test_relative_path 0.00s setup test_user_directories/test.py::test_mixed_style 0.00s teardown test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch 0.00s teardown test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s teardown test_storage_s3_queue/test.py::test_settings_check 0.00s teardown test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] 0.00s teardown test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s teardown test_user_directories/test.py::test_memory 0.00s teardown test_user_directories/test.py::test_mixed_style 0.00s teardown test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s teardown test_table_function_redis/test.py::test_data_type 0.00s teardown test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_system_flush_logs/test.py::test_system_logs_non_empty_queue =========================== short test summary info ============================ FAILED test_storage_s3_queue/test.py::test_upgrade - helpers.client.QueryRunt... PASSED test_system_flush_logs/test.py::test_system_logs[system.metric_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.part_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1] PASSED test_system_flush_logs/test.py::test_system_logs[system.text_log-0] PASSED test_system_flush_logs/test.py::test_system_logs[system.trace_log-1] PASSED test_system_flush_logs/test.py::test_system_logs_non_empty_queue PASSED test_system_flush_logs/test.py::test_system_suspend PASSED test_throttling/test.py::test_backup_throttling[no_local_throttling] PASSED test_storage_url_with_proxy/test.py::test_s3_with_proxy_list PASSED test_user_directories/test.py::test_duplicates PASSED test_table_function_mongodb/test.py::test_auth_source[False] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] PASSED test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart1 PASSED test_user_directories/test.py::test_local_directories PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling] PASSED test_transactions/test.py::test_rollback_unfinished_on_restart2 PASSED test_table_function_redis/test.py::test_create_table PASSED test_table_function_redis/test.py::test_data_type PASSED test_user_directories/test.py::test_memory PASSED test_table_function_redis/test.py::test_simple_select PASSED test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling] PASSED test_user_valid_until/test.py::test_basic PASSED test_user_valid_until/test.py::test_details PASSED test_user_directories/test.py::test_mixed_style PASSED test_truncate_database/test_distributed.py::test_truncate_database_distributed PASSED test_user_directories/test.py::test_old_style PASSED test_throttling/test.py::test_backup_throttling[server_local_throttling] PASSED test_user_directories/test.py::test_relative_path PASSED test_version_update_after_mutation/test.py::test_mutate_and_upgrade PASSED test_table_function_mongodb/test.py::test_secure_connection[True] PASSED test_version_update_after_mutation/test.py::test_upgrade_while_mutation PASSED test_storage_s3_queue/test.py::test_max_set_age PASSED test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling] PASSED test_text_log_level/test.py::test_basic PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling] PASSED test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling] PASSED test_storage_s3_queue/test.py::test_max_set_size PASSED test_table_function_mongodb/test.py::test_simple_select[False] PASSED test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch PASSED test_zookeeper_config/test_secure.py::test_secure_connection PASSED test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue PASSED test_throttling/test.py::test_backup_throttling[user_local_throttling] PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered] PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered] PASSED test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling] PASSED test_store_cleanup/test.py::test_store_cleanup PASSED test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling] PASSED test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling] PASSED test_storage_s3_queue/test.py::test_processed_file_setting[1] PASSED test_storage_s3_queue/test.py::test_processed_file_setting[5] PASSED test_throttling/test.py::test_backup_throttling_override PASSED test_throttling/test.py::test_max_merges_bandwidth_for_server PASSED test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1] PASSED test_throttling/test.py::test_max_mutations_bandwidth_for_server PASSED test_system_clusters_actual_information/test.py::test PASSED test_throttling/test.py::test_read_throttling[no_local_throttling] PASSED test_throttling/test.py::test_read_throttling[no_remote_throttling] PASSED test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5] PASSED test_throttling/test.py::test_read_throttling[server_local_throttling] PASSED test_storage_s3_queue/test.py::test_processing_threads[ordered] PASSED test_storage_s3_queue/test.py::test_processing_threads[unordered] PASSED test_throttling/test.py::test_read_throttling[server_remote_throttling] PASSED test_storage_s3_queue/test.py::test_s3_client_reused PASSED test_throttling/test.py::test_read_throttling[user_local_throttling] PASSED test_storage_s3_queue/test.py::test_settings_check PASSED test_throttling/test.py::test_read_throttling[user_remote_throttling] PASSED test_storage_s3_queue/test.py::test_shards[ordered-1] PASSED test_throttling/test.py::test_write_throttling[local_server_throttling] PASSED test_storage_s3_queue/test.py::test_shards[ordered-8] PASSED test_throttling/test.py::test_write_throttling[local_user_throttling] PASSED test_throttling/test.py::test_write_throttling[no_local_throttling] PASSED test_storage_s3_queue/test.py::test_shards[unordered-1] PASSED test_throttling/test.py::test_write_throttling[no_remote_throttling] PASSED test_throttling/test.py::test_write_throttling[server_remote_throttling] PASSED test_storage_s3_queue/test.py::test_shards[unordered-8] PASSED test_throttling/test.py::test_write_throttling[user_remote_throttling] PASSED test_storage_s3_queue/test.py::test_shards_distributed[ordered-1] PASSED test_storage_s3_queue/test.py::test_shards_distributed[ordered-8] PASSED test_storage_s3_queue/test.py::test_shards_distributed[unordered-1] PASSED test_storage_s3_queue/test.py::test_shards_distributed[unordered-8] PASSED test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered] PASSED test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered] PASSED test_storage_s3_queue/test.py::test_streaming_to_view_[ordered] PASSED test_storage_s3_queue/test.py::test_streaming_to_view_[unordered] ============ 1 failed, 91 passed, 22 warnings in 391.92s (0:06:31) ============= Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_0zvd8x --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_s3_queue/test.py::test_max_set_age test_storage_s3_queue/test.py::test_max_set_size test_storage_s3_queue/test.py::test_multiple_tables_meta_mismatch 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync[unordered]' 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[ordered]' 'test_storage_s3_queue/test.py::test_multiple_tables_streaming_sync_distributed[unordered]' 'test_storage_s3_queue/test.py::test_processed_file_setting[1]' 'test_storage_s3_queue/test.py::test_processed_file_setting[5]' 'test_storage_s3_queue/test.py::test_processed_file_setting_distributed[1]' 'test_storage_s3_queue/test.py::test_processed_file_setting_distributed[5]' 'test_storage_s3_queue/test.py::test_processing_threads[ordered]' 'test_storage_s3_queue/test.py::test_processing_threads[unordered]' test_storage_s3_queue/test.py::test_s3_client_reused test_storage_s3_queue/test.py::test_settings_check 'test_storage_s3_queue/test.py::test_shards[ordered-1]' 'test_storage_s3_queue/test.py::test_shards[ordered-8]' 'test_storage_s3_queue/test.py::test_shards[unordered-1]' 'test_storage_s3_queue/test.py::test_shards[unordered-8]' 'test_storage_s3_queue/test.py::test_shards_distributed[ordered-1]' 'test_storage_s3_queue/test.py::test_shards_distributed[ordered-8]' 'test_storage_s3_queue/test.py::test_shards_distributed[unordered-1]' 'test_storage_s3_queue/test.py::test_shards_distributed[unordered-8]' 'test_storage_s3_queue/test.py::test_streaming_to_many_views[ordered]' 'test_storage_s3_queue/test.py::test_streaming_to_many_views[unordered]' 'test_storage_s3_queue/test.py::test_streaming_to_view_[ordered]' 'test_storage_s3_queue/test.py::test_streaming_to_view_[unordered]' test_storage_s3_queue/test.py::test_upgrade test_storage_url_with_proxy/test.py::test_s3_with_proxy_list test_store_cleanup/test.py::test_store_cleanup test_system_clusters_actual_information/test.py::test test_system_ddl_worker_queue/test.py::test_distributed_ddl_queue 'test_system_flush_logs/test.py::test_system_logs[system.metric_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.part_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.query_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.query_thread_log-1]' 'test_system_flush_logs/test.py::test_system_logs[system.text_log-0]' 'test_system_flush_logs/test.py::test_system_logs[system.trace_log-1]' test_system_flush_logs/test.py::test_system_logs_non_empty_queue test_system_flush_logs/test.py::test_system_suspend 'test_table_function_mongodb/test.py::test_auth_source[False]' 'test_table_function_mongodb/test.py::test_complex_data_type[False]' 'test_table_function_mongodb/test.py::test_incorrect_data_type[False]' 'test_table_function_mongodb/test.py::test_missing_columns[False]' 'test_table_function_mongodb/test.py::test_no_credentials[False]' 'test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]' 'test_table_function_mongodb/test.py::test_secure_connection[True]' 'test_table_function_mongodb/test.py::test_simple_select[False]' test_table_function_redis/test.py::test_create_table test_table_function_redis/test.py::test_data_type test_table_function_redis/test.py::test_simple_select test_text_log_level/test.py::test_basic 'test_throttling/test.py::test_backup_throttling[no_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[no_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[server_remote_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_local_to_remote_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_local_throttling]' 'test_throttling/test.py::test_backup_throttling[user_remote_to_remote_throttling]' test_throttling/test.py::test_backup_throttling_override test_throttling/test.py::test_max_merges_bandwidth_for_server test_throttling/test.py::test_max_mutations_bandwidth_for_server 'test_throttling/test.py::test_read_throttling[no_local_throttling]' 'test_throttling/test.py::test_read_throttling[no_remote_throttling]' 'test_throttling/test.py::test_read_throttling[server_local_throttling]' 'test_throttling/test.py::test_read_throttling[server_remote_throttling]' 'test_throttling/test.py::test_read_throttling[user_local_throttling]' 'test_throttling/test.py::test_read_throttling[user_remote_throttling]' 'test_throttling/test.py::test_write_throttling[local_server_throttling]' 'test_throttling/test.py::test_write_throttling[local_user_throttling]' 'test_throttling/test.py::test_write_throttling[no_local_throttling]' 'test_throttling/test.py::test_write_throttling[no_remote_throttling]' 'test_throttling/test.py::test_write_throttling[server_remote_throttling]' 'test_throttling/test.py::test_write_throttling[user_remote_throttling]' test_transactions/test.py::test_rollback_unfinished_on_restart1 test_transactions/test.py::test_rollback_unfinished_on_restart2 test_truncate_database/test_distributed.py::test_truncate_database_distributed test_user_directories/test.py::test_duplicates test_user_directories/test.py::test_local_directories test_user_directories/test.py::test_memory test_user_directories/test.py::test_mixed_style test_user_directories/test.py::test_old_style test_user_directories/test.py::test_relative_path test_user_valid_until/test.py::test_basic test_user_valid_until/test.py::test_details test_version_update_after_mutation/test.py::test_mutate_and_upgrade test_version_update_after_mutation/test.py::test_upgrade_while_mutation test_zookeeper_config/test_secure.py::test_secure_connection -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.